package com.example.swaggerDemo.Dao;

import com.example.swaggerDemo.entity.SalaryEntity;
import org.springframework.web.bind.annotation.RequestParam;

import java.sql.SQLException;
import java.util.List;

public interface SalaryDao {
    List<SalaryEntity> findOpenid(@RequestParam("openid") String openid, @RequestParam("status") String status, @RequestParam("pageindex") int pagindex,
                                  @RequestParam("pagesize") int pagesize);

    SalaryEntity findid(@RequestParam("id") String id, @RequestParam("status") String status);

    int updateOrderType(@RequestParam("id") String id, @RequestParam("status") Integer status);

    int updateOrderTypeUpid(@RequestParam("id") String id, @RequestParam("status") Integer status, @RequestParam("upid") Integer upid,@RequestParam("userimg") String userimg);

    int insert(@RequestParam("openid") String openid, @RequestParam("money") String money);

    int insertTx(@RequestParam("openid") String openid, @RequestParam("money") String money, @RequestParam("kaihuhang") String kaihuhang, @RequestParam("yinhangka") String yinhangka,@RequestParam("remake") String remake,@RequestParam("nickname") String nickname, @RequestParam("userimg") String userimg);

    int insert(@RequestParam("openid") String openid, @RequestParam("money") String money,@RequestParam("orderid") String orderid,  @RequestParam("type") String type, @RequestParam("nickname") String nickname );

    List<SalaryEntity> findByupid(@RequestParam("upid") String upid) throws SQLException;

    SalaryEntity findByid(@RequestParam("id") String id) throws SQLException;

    List<SalaryEntity>  findByUserid(@RequestParam("orderid") String orderid) throws SQLException;

    List<SalaryEntity> findadmin(@RequestParam("status") String status, @RequestParam("pageindex") int pagindex, @RequestParam("pagesize") int pagesize) throws SQLException;
}
